131

Real-Time Currency Conversion

131

As soon as you press it, the

button is going to take you

the original page. Use the

crosshairs to click on the field

you want to inspect. In this

picture I clicked on the field

that accepts input, see the red

crosshairs that show up. As

soon as I click, it takes me

back to the developer view

(see below)

This developer view now

highlights the field you are

interested in and shows us

the details of how to identify

it. For example, it shows that

the class of this field is called

“gLFyf gsfi”

HTML works in tags and it is hierarchical. Understanding this is key to writing a

successful program.

Selection criteria field:

This can be easily identified by its Class (“gLFyf gsfi”)

Trigger field:

This is the field called “Google Search” on the webpage. This is also iden­

tified by its Class. The first time you launch google this field belongs to

class “gNO89b”, but the second time onwards it is a different class field

(“Tg7LZd”)

9.3  OUTPUT FIELD

The output field is also identified a class value of “DFlfde SwHCTb”. The value

displayed by the webpage (the currency conversion rate) is accessed through a

fieldname called “innertext”.

In order to use the web processing HTML functions, the following options are neces­

sary in the Excel VBA, accessed by the menu path Tools -​> References in the VBA

development screen.